<%-- 
    Document   : ProsesEdit
    Created on : Dec 6, 2012, 1:20:10 AM
    Author     : Boriz
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
    "http://www.w3.org/TR/html4/loose.dtd">

<%@ page import="java.sql.*" %>
<%
            String id = request.getParameter("tf_id");
            String nama = request.getParameter("tf_nama");
            //   String alamat = request.getParameter("tf_alamat");
            // String notlp = request.getParameter("tf_telp");
            //String email = request.getParameter("tf_email");
            // tanggal = request.getParameter("tf_tanggal");
            //String gender = request.getParameter("tf_gender");
            //   String paket = request.getParameter("tf_paket");
            String bayar = request.getParameter("tf_bayar");

            Connection con = null;
            //String dbname = "jdbc:oracle:thin:@localhost:1521:XE";
            String dbname = "jdbc:oracle:thin:@172.23.9.185:1521:orcl";
            String status = "";
            ResultSet rs = null;
            Statement st = null;
            try {
                Class.forName("oracle.jdbc.driver.OracleDriver");
                //con = DriverManager.getConnection(dbname, "hr", "hr");
                con = DriverManager.getConnection(dbname, "MHS105314093", "MHS105314093");
                if (con == null) {
                    status = "gagal";
                } else {
                    status = "berhasil";
                }
            } catch (ClassNotFoundException ex) {
                status = "Driver Error";
            } catch (SQLException ex) {
                status = "gagal";
            }

            /**
             * Menyiapkan kueri
             */
            String kueri = "update rplopesanan set idpesanan = '" + id + "',"
                    + " nama = '" + nama + "',"
                    // + " paket = '" + paket + "',"
                    + " status = '" + bayar + "'"
                    + " where idpesanan = '" + id + "'";
            st = con.createStatement();
            int editTabel = st.executeUpdate(kueri);
            st.close();
            con.close();




%>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>Cyber Tour & Travel</title>
</head>
<body>
<style type="text/css">
    #main{
        border: solid;
        color: blue;
        background:white;
        font-weight: bold;
        margin-top: 100px;
        margin-left:120px;
        margin-right:127px;
        margin-bottom:135px;
        padding-right:60px; }

    #menuhor {
        list-style-type: none;
        margin: 0;
        padding: 0;
        float: center;
    }

    #menuhor li {
        margin: 0;
        padding: 0;
        float:left;
        text-align : center;
    }

    #menuhor a {
        display: block;
        width : 247px;
        color: #FFF;
        float : center;
        text-decoration: none;
        line-height:2.5;
        border-right: 3px solid white;
    }

    #menuhor a:hover {
        background: cyan;
    }
    #konten_utama{
        background-color:white;}

    #menuver{
        list-style-type: none;
        margin-left:-40px;
        margin-right:30px;
        padding:0;
        width : 170px;
        background-color:white;
        float:left;
    }
    #menuver li {
        margin:0;
        padding:0;
        float:center;
        text-align : center;
    }
    #menuver a {
        display:block;
        color:#FFF;
        text-decoration:none;
        padding:0.15px;
        line-height: 2.5;
        border-bottom: 3px solid white;
    }
    #menuver a:hover {
        background: cyan;
    }
    #footer{
        font-size: 14px;
        border: solid;
        color: blue;
        clear:both;
        text-align: center;
        background: white;
        margin-top: 350px;
        margin-bottom: 50px;
        height:70px;
        width :950px;
        float:center;

    }
    #konten{
        float:left;

        color: black;
        background: white;
        height:400px;
        width :730px
    }



</style>
<body background ="background1.jpg">
    <ul id="main">
        <center><img src="banner.jpg"width="1000" height="300">

            <br>
            <ul id="menuhor" style="position:absolute;right:7px;left:173px;top:345px">
                <font face="Comic sans MS">
                    <li><a href="HalamanUtama.jsp"><font color="Blue">Home</a> </li>
                    <li><a href="HalamanProfile.jsp"><font color="Blue">Profile</a></li>
                    <li><a href="HalamanWisata.jsp"><font color="Blue">Wisata</blink></a></li>
                    <li><a href="FormOrder.jsp"><font color="Blue">Order</a></li>
            </ul><br><br><hr>

            <ul id="konten_utama">

                <ul id="menuver">
                    <center> Klik the link below to view packet travel</center>
                    <br>
                    <li><a href="HalamanWisata.jsp"><Marquee><font color="Blue">view packet travel </Marquee></a> </li>
                    <br>
                </ul>

                <ul id="konten">
                    <form name="form1" method="post" action="HalamanPesanan.jsp">
                        <%
                                    if (editTabel == 1) {
                                        out.println("Edit data berhasil");
                                    } else {
                                        out.println("Edit data gagal");
                                    }
                        %>
                        <INPUT TYPE="submit" VALUE="Lihat Pesanan">
                    </form></ul>
                    <ul id="footer">

                        Queries Executed: 0 queries | Page Generation Time: 0.00265 seconds <br>
                        Travel Agent 2.0.4 Beta 10 (Revision 363). Coded by Ardy. Skin coded by Amel and designed by Fave, Hohok
                        All registered trademarks belong to their respective owners. Travel Agent Online and all related content are trademark of Gravity CO. Ltd.
                    </ul></font>
                    </body>
                    </html>



